UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idwiQjfF6Q1LKXafJNBrzo/X3JtMIicU4g/2lCxNy6E='
WHERE
key_id = 'e7b6df75a2dcccb7a3762bc128a217da9d283085556c45a99b7a53657013594f'
AND (
token = 'idwiQjfF6Q1LKXafJNBrzo/X3JtMIicU4g/2lCxNy6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)