UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1XkGUzm2+mtDoLlrsHuaapdhakoLF5nKM3M21y5sK+c='
WHERE
key_id = 'c767866a4aeb3d966dd7df2b9bbed5bed0663aef2a8ce8e9d42e7e0221000258'
AND (
token = '1XkGUzm2+mtDoLlrsHuaapdhakoLF5nKM3M21y5sK+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)