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