UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pn+0Y1jVpsaTkCdUHzrXLKwgm7R8NuoKlqDRQDhZW+0='
WHERE
key_id = '7a04ee9fe1051bbc79129c84fa07220e4266f6b904545cd5d53156e3eb631039'
AND (
token = 'Pn+0Y1jVpsaTkCdUHzrXLKwgm7R8NuoKlqDRQDhZW+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)