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