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