UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bc5Zt3qR4dNR8mp2anDxFjfjPRuThlAyT2fNsq5UobA='
WHERE
key_id = '8bac00ce691b6e9611fe42e4328c88487c685c2a6882dde1a9fd6eee40d43186'
AND (
token = 'bc5Zt3qR4dNR8mp2anDxFjfjPRuThlAyT2fNsq5UobA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)