UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HePEk892nr51c7NoZWnntu8R+mV6OuDguL/q/rrAU9M='
WHERE
key_id = '3ce4a01d771e405dbdf8e6f74c9706b16ba936e56b93f99951f726113316875f'
AND (
token = 'HePEk892nr51c7NoZWnntu8R+mV6OuDguL/q/rrAU9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)