UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OYHLE2oCuetzRXow+ot/fS9fLIsa1AswpQzLbLM3UZI='
WHERE
key_id = 'ccc8fa78aa4462c8d7bc2dcd43e9c25bba243695741a12da9de9ad9c888e5956'
AND (
token = 'OYHLE2oCuetzRXow+ot/fS9fLIsa1AswpQzLbLM3UZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)