UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dKh1ohEGnolQmTYt+Y6XZnrbmP0WAbAeRNilhrXhiQw='
WHERE
key_id = '999a8d97236edbe1b1a391d92fad5f804f2f6855acaf87262788b681732c5011'
AND (
token = 'dKh1ohEGnolQmTYt+Y6XZnrbmP0WAbAeRNilhrXhiQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)