UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yRBMkURRLlhMMsS6qIIuvQnw3ys7txZVy64qwEd+j3w='
WHERE
key_id = 'aff2c03116f8ef64d7ee3c96039509501895745779a4a74463fc277517afe178'
AND (
token = 'yRBMkURRLlhMMsS6qIIuvQnw3ys7txZVy64qwEd+j3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)