UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XkjqArVLBe5tumxiXc8xTypPLA/fZo3oH5ehbVUE12w='
WHERE
key_id = 'bb6c6cf78d8486865fe86a6ccca6dd0a4989ff6ccbee58382724d44b7472a1e9'
AND (
token = 'XkjqArVLBe5tumxiXc8xTypPLA/fZo3oH5ehbVUE12w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)