UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/kFQwNYbgqh8keUdxXYj8qRPooL9uWsag8M7hpUXt4M='
WHERE
key_id = '36d64ab30182034abc0793da76d9122563c6b97b8b7ebb3796a3c2ac564efcf0'
AND (
token = '/kFQwNYbgqh8keUdxXYj8qRPooL9uWsag8M7hpUXt4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)