UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aWMrt+I4+Fj7wxuFDOF5wX6ISEAU2J5ZX3u/w279hB8='
WHERE
key_id = '878be2ff984a3776b734c8591b13a49591ba7401ceff44cbb28c82534afc5a12'
AND (
token = 'aWMrt+I4+Fj7wxuFDOF5wX6ISEAU2J5ZX3u/w279hB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)