UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3tBB5eHebqa7flcG6huiN8Y75gWIKGCmobtKg40lVsM='
WHERE
key_id = 'd911ff879093da951c42def0c216d1f97dba01228f77457d0c8d75205d17d2d3'
AND (
token = '3tBB5eHebqa7flcG6huiN8Y75gWIKGCmobtKg40lVsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)