UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bk54INGhJjA0GFi/3lxzedbivR7WRhBi2Y+ZVEHZXBo='
WHERE
key_id = 'e63e781abfce149479b686ad007bbe35c09b177e1ed5a4fa065e2e5700f0a9fb'
AND (
token = 'Bk54INGhJjA0GFi/3lxzedbivR7WRhBi2Y+ZVEHZXBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)