UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4pO0P6f3i8/519kO1JR3RMeRgyTUfVbnIQl241Agqs='
WHERE
key_id = '97816ef4ff97d28e68ac5edda6d9293d236bb532cbcad37606a13b5e6d2a29fd'
AND (
token = 'H4pO0P6f3i8/519kO1JR3RMeRgyTUfVbnIQl241Agqs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)