UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HfKxDD6HH65o/0LIfHVMpL/D4UgAAkQh0wPag0Lngps='
WHERE
key_id = 'bc6cc40744128879c9f49f14b6d7ae285d177c5cf88d6b2c4d37d7ac255575fc'
AND (
token = 'HfKxDD6HH65o/0LIfHVMpL/D4UgAAkQh0wPag0Lngps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)