UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w5DEbGoJxuIgIOcO9nfI3PDwox/O6tYkgUDpk22cv9A='
WHERE
key_id = '3233c5e0d639d1d73670682c971a1ee45220d67b5aedd03dff51f034836cd13a'
AND (
token = 'w5DEbGoJxuIgIOcO9nfI3PDwox/O6tYkgUDpk22cv9A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)