UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hdhTkG2ya0SNqmX0OBmW+41hpyA2/jeqrbBApy44htM='
WHERE
key_id = 'c04e43cb174f3598171a7cb285e7355dbb3260737e16cecdb3fb1b5b1cfb05bb'
AND (
token = 'hdhTkG2ya0SNqmX0OBmW+41hpyA2/jeqrbBApy44htM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)