UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1XU1jlWG5KcOuVk8D1XS2PAu68zBCX/BCaXtwieK/QQ='
WHERE
key_id = '31502d0b8b5fc788e7262a8f2920534beeefe340c7b488516f90741c9a526939'
AND (
token = '1XU1jlWG5KcOuVk8D1XS2PAu68zBCX/BCaXtwieK/QQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)