UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SzSwr1cvWHi6pyB7qbAjC2hx4LhU1ZeTukuPyappnas='
WHERE
key_id = 'e823e3777ba76fc7363f34b841bfd129a32ef685a22f3e81e23ec0c4c1fb7ebe'
AND (
token = 'SzSwr1cvWHi6pyB7qbAjC2hx4LhU1ZeTukuPyappnas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)