UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxJKkCtKpaQyjD7W7iNPVX63NpQ05GqfNcdRl+7FkTM='
WHERE
key_id = '4c66c7f5412136c3966d49df0c78476e6e2b406b3067b83c6d8db298db09a641'
AND (
token = 'zxJKkCtKpaQyjD7W7iNPVX63NpQ05GqfNcdRl+7FkTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)