UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bM1pB5shn6TTENgt2soVKP9yGbUPdGg9zq1IlIb7VoM='
WHERE
key_id = 'd538cea4b184d75b4b51811fefa51641b8178d672af6f9d28fbd3c680c15e232'
AND (
token = 'bM1pB5shn6TTENgt2soVKP9yGbUPdGg9zq1IlIb7VoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)