UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1PnmxX/t6ygpD0H+N6T4Gf4ZACjvCNGbnoHmY3aiecw='
WHERE
key_id = '5f3bcac763fe7d6eb3b8b9e50825cfff8e9f53989ad86a70f9d5bf81d211387f'
AND (
token = '1PnmxX/t6ygpD0H+N6T4Gf4ZACjvCNGbnoHmY3aiecw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)