UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HoYocnlPMc+xI0xW0CVDnj49cDkxeXRNbT+MQUthv54='
WHERE
key_id = 'f4dcb1cd7eba94c06fbdb07b0decd68d5300bd675f13a93c2adcd73a13df277b'
AND (
token = 'HoYocnlPMc+xI0xW0CVDnj49cDkxeXRNbT+MQUthv54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)