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