UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJ9RYoVmO6dnHPiClXCXRFNR1FFwh+U+fkF8+PN8Jz8='
WHERE
key_id = 'ca9fbd11734f4792aec3d726819fd5f6b8739a8ca482ee906e57cf497ef46f32'
AND (
token = 'XJ9RYoVmO6dnHPiClXCXRFNR1FFwh+U+fkF8+PN8Jz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)