UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ick/H672/gZgUdqliu5T8pgBYA5lDt8mJpM/PRw0YHI='
WHERE
key_id = 'dcab9eb053d0ec170a8820a0a19c64d5e13f3d17a4ed1938328e117f62fff647'
AND (
token = 'ick/H672/gZgUdqliu5T8pgBYA5lDt8mJpM/PRw0YHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)