UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd8uKm+MUzgHzl8auhSl8JC0V4UayVM7nmGRPesyjfyw='
WHERE
key_id = 'a455e94e232e0312b7521a56b08afc8b86ad1019db07d9c457190615b7880203'
AND (
token = 'd8uKm+MUzgHzl8auhSl8JC0V4UayVM7nmGRPesyjfyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)