UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZZuw07gdK0EAmhH8Dgh8uJZenxbmqBu5y0d/5cVy9w='
WHERE
key_id = '29b5f6702afccb6ae12e3d54ef3339f15757a0528509020f34c0310c5ab154ab'
AND (
token = 'dZZuw07gdK0EAmhH8Dgh8uJZenxbmqBu5y0d/5cVy9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)